{"text_format":"1","workbook":"xls","n_sheets":3,"sheets":["Explanation","Example","Spreadsheet"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Explanation","index":0,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[]
[]
[]
[null,null,"IRA Investment Reallocation"]
[]
[null,null,"This spreadsheet helps you to reallocate your investments in your IRA. Enter your "]
[null,null,"current IRA investments by category. Then input the new percentages (new "]
[null,null,"allocation %). The Change Needed column calculates the amounts by which "]
[null,null,"you will need to increase accounts (negative numbers represent the amounts "]
[null,null,"by which you need to decrease accounts)."]
[]
[null,null,"Be sure that your new allocation percentages total 100%.  Also be sure that the "]
[null,null,"total current allocation amount equals the total you currently have invested."]
[]
[null,null,"Data input cells are shaded. All other cells are protected."]

{"sheet":"Example","index":1,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["IRA Investment Reallocation Planner"]
[]
[null,"Total currently invested",44000,null,null,"Date","1999-02-02"]
[]
[null,null,"Current",null,"New","New","Change "]
[null,"Investments","Allocation $","Current %","Allocation %","Allocation ","Needed"]
[null,"Stock Fund",12000,0.2727272727272727,0.7,30799.999999999996,18799.999999999996]
[null,"Fixed Income Fund",2000,0.045454545454545456,0.2,8800,6800]
[null,"Government Fund",30000,0.6818181818181818,0.1,4400,-25600]
[null,null,null,"",null,"",""]
[null,null,null,"",null,"",""]
[null,null,null,"",null,"",""]
[null,null,null,"",null,"",""]
[null,null,null,"",null,"",""]
[null,null,null,"",null,"",""]
[null,null,null,"",null,"",""]
[null,null,null,"",null,"",""]
[null,null,null,"",null,"",""]
[null,null,null,"",null,"",""]
[null,null,null,"",null,"",""]
[null,null,null,"",null,"",""]
[null,null,44000,1,0.9999999999999999,44000,-3.637978807091713e-12]

{"sheet":"Spreadsheet","index":2,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["IRA Investment Reallocation Planner"]
[]
[null,"Total currently invested",null,null,null,"Date"]
[]
[null,null,"Current",null,"New","New","Change "]
[null,"Investments","Allocation $","Current %","Allocation %","Allocation ","Needed"]
[null,null,null,"",null,"",""]
[null,null,null,"",null,"",""]
[null,null,null,"",null,"",""]
[null,null,null,"",null,"",""]
[null,null,null,"",null,"",""]
[null,null,null,"",null,"",""]
[null,null,null,"",null,"",""]
[null,null,null,"",null,"",""]
[null,null,null,"",null,"",""]
[null,null,null,"",null,"",""]
[null,null,null,"",null,"",""]
[null,null,null,"",null,"",""]
[null,null,null,"",null,"",""]
[null,null,null,"",null,"",""]
[null,null,null,"",null,"",""]
[null,null,"","","","",""]